
Use NEXUS_DB

GO
--------------------------------------Insert---------------
CREATE PROC insertFeedBack 
	 @CustomerID   int  ,
	 @Title   nvarchar (255) ,
	 @content   nvarchar (500),
	 @Date   datetime 
AS
INSERT INTO  FeedBack(CustomerID,Title,[content],Date) 
VALUES(@CustomerID,@Title,@content,@Date) 

--insertAccount 'da',1,1,1
GO
---------------------------------------------------update-------------------
CREATE PROC updateStatusFeedBack 
	 @FeedbackID   int  
AS
UPDATE FeedBack SET	
	 Status=1
WHERE FeedbackID=@FeedbackID
GO
---------------------------------------Delete--------------------

CREATE PROC deleteFeedBack
	@FeedbackID   int
AS
	DELETE FROM FeedBack WHERE FeedbackID=@FeedbackID
GO
CREATE PROC getAllFeedBack
AS
SELECT * from FeedBack
GO
-------------------------------getFeedBackByID--------------------

CREATE PROC getFeedBackByID
	@FeedbackID   int
AS
SELECT * from FeedBack WHERE FeedbackID=@FeedbackID
GO

